/*
 Navicat Premium Data Transfer

 Source Server         : cdb-f80kyr0n.gz.tencentcdb.com
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : cdb-f80kyr0n.gz.tencentcdb.com:10077
 Source Schema         : initialize_db

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 25/05/2021 19:32:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `u_login` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '账号',
  `u_psd` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '密码',
  `u_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号',
  `u_phone` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  `u_struts` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'normal' COMMENT '状态',
  `role_id` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '角色',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (0, '123', '$2a$10$uOpDkkHRBhLm5o9q8OvJaOWH4YXNv6BvH9L9sDEYwdxbhKi6PsYeC', '不可删除,不可禁用', '000000', '这个密码是111', 'normal', '1', '2020-06-15 02:58:43', '2020-07-10 15:29:59');
INSERT INTO `admin` VALUES (21, '3428', '$2a$10$41.DIPw59z4va6khnu5w0OFVGpiXGxVwfh931olz5y/5CxhYlunAy', '管理员', '111111', NULL, 'normal', '2,1', '2020-06-16 17:18:57', '2020-06-16 17:19:14');
INSERT INTO `admin` VALUES (22, '3878', '$2a$10$W2maUdnu65RCja4ueBvrcOd.geBONF9fBGYprCiIKUlhb76ixgulu', '123', '123', NULL, 'normal', '1', '2020-06-18 10:57:41', NULL);
INSERT INTO `admin` VALUES (23, '9266', '$2a$10$2Njp8MbT5e/nB0/ekbGfm.AiEjrvhesA9vr4tr5ymFm9zBIPub5iq', '老王老王', '10086', NULL, 'deleted', '1,2', '2020-06-18 10:58:21', '2020-06-18 10:59:48');
INSERT INTO `admin` VALUES (24, '5554', '$2a$10$h2d6XPpWgRVtNW46ridIR.sxIgkXjwepcwA/J3GtlI7tlUgN9i5Ze', '安东风', '奥赛分', NULL, 'deleted', '1', '2020-06-18 10:59:24', '2020-06-18 10:59:46');
INSERT INTO `admin` VALUES (25, '7594', '$2a$10$OytqUryqDve1N25P.ag0RuUgge8aUIt0kG6UDx7ru64DjDT4Nh35q', '用户', '111111', NULL, 'normal', '2,1', '2020-06-19 13:48:33', '2020-06-19 13:49:16');
INSERT INTO `admin` VALUES (38, '555', '$2a$10$kA56QK/PHWMzxTULvT0MLuK0mICxThwbhWWZu7Xn7sm48ysdrB..W', '555', '555', '用于测试', 'normal', '2,1', '2020-07-10 07:27:16', '2020-07-10 15:29:46');
COMMIT;

-- ----------------------------
-- Table structure for image
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '主键',
  `img_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片ID                  用于和对用的数据相关联',
  `img_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片地址',
  `img_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片的原始名称',
  `hash` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '存储对象存储中的key',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  `remark` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片备注                 用于简单的标记图片的用途',
  `state` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT 'normal' COMMENT '数据状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='图片';

-- ----------------------------
-- Records of image
-- ----------------------------
BEGIN;
INSERT INTO `image` VALUES ('1594962025610d2c5f', NULL, '4ee74b8a472f9d0fce5bb027597e4fe6.jpg', NULL, 'FtR19FZafsWQIcP5xWzBm740W5F8', NULL, 'logo_05.jpg', 'normal', '2020-07-17 13:00:25', NULL);
INSERT INTO `image` VALUES ('1594963362389cb744', NULL, '7ed2a617c7aa8bbd5c69433bbc8311e0.jpg', NULL, 'FtR19FZafsWQIcP5xWzBm740W5F8', NULL, 'logo_05.jpg', 'normal', '2020-07-17 13:22:42', NULL);
INSERT INTO `image` VALUES ('1594964217508114d2', NULL, '7decb121be61b630002597d713e1d932.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 13:36:57', NULL);
INSERT INTO `image` VALUES ('1594964282244b0955', NULL, 'dcf60678fbc51d578dc502adc40f99c4.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 13:38:02', NULL);
INSERT INTO `image` VALUES ('1594964544516ac2f0', NULL, 'null149781908ab6bc7b509be3819a0bc5dd.png', NULL, 'Fs-qdCoObJea1O_3j6Y8FEhLyZF7', NULL, '藏器于身, 待时而动.png', 'normal', '2020-07-17 13:42:24', NULL);
INSERT INTO `image` VALUES ('15949648029165cd4e', NULL, 'null79165407ac28dc6c8a44ed4b0c8a5dd6.png', NULL, 'Fs-qdCoObJea1O_3j6Y8FEhLyZF7', NULL, '藏器于身, 待时而动.png', 'normal', '2020-07-17 13:46:43', NULL);
INSERT INTO `image` VALUES ('159496484117111d83', NULL, 'http://qdlmtopf1.bkt.clouddn.com/a4220f6bf78f6e0f4951b2dfe64c62e1.png', NULL, 'Fs-qdCoObJea1O_3j6Y8FEhLyZF7', NULL, '藏器于身, 待时而动.png', 'normal', '2020-07-17 13:47:21', NULL);
INSERT INTO `image` VALUES ('15949650420344ab28', NULL, 'http://qdlmtopf1.bkt.clouddn.com/5bbb93979e2fd6733ebb0c1d09110fa1.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 13:50:42', NULL);
INSERT INTO `image` VALUES ('1594965168687917b9', NULL, 'http://qdlmtopf1.bkt.clouddn.com/8bd614226e7df5de5057c8324bb43b25.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 13:52:48', NULL);
INSERT INTO `image` VALUES ('15949656859661a847', NULL, 'http://qdlmtopf1.bkt.clouddn.com/f32e79cfdf676eb73db8b851d8ec2fb8.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 14:01:26', NULL);
INSERT INTO `image` VALUES ('1594966092312e1b68', NULL, 'http://qdlmtopf1.bkt.clouddn.com/657a6a410a00dd2e190d7cba685655dc.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 14:08:12', NULL);
INSERT INTO `image` VALUES ('1594966429256fc65b', NULL, 'http://qdlmtopf1.bkt.clouddn.com/8659daa8a3742d2fae560a103e2228df.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 14:13:49', NULL);
INSERT INTO `image` VALUES ('159496718638085bb9', NULL, 'http://qdlmtopf1.bkt.clouddn.com/005b56a6795f11e58dee1f48ccc2fa47.jpg', NULL, 'Fjo3gS95C9ksiqi29kgWo9U62NNP', NULL, 'tu.jpg', 'normal', '2020-07-17 14:26:26', NULL);
INSERT INTO `image` VALUES ('15949673224185a13b', NULL, 'http://qdlmtopf1.bkt.clouddn.com/d265783f6e80cc9d35129192f16f5914.png', NULL, 'FrWpoAZhtyw5uqAkeLktqeZyJoz1', NULL, 'home-active.png', 'normal', '2020-07-17 14:28:42', NULL);
INSERT INTO `image` VALUES ('159496739250631587', NULL, 'http://qdlmtopf1.bkt.clouddn.com/601c5ebb443cf6d42c3a145b6c1fce66.png', NULL, 'FrWpoAZhtyw5uqAkeLktqeZyJoz1', NULL, 'home-active.png', 'normal', '2020-07-17 14:29:52', NULL);
INSERT INTO `image` VALUES ('1594967467793a458b', NULL, 'http://qdlmtopf1.bkt.clouddn.com/7cb9a600cea4a57c489b31eac2e187c2.png', NULL, 'FrWpoAZhtyw5uqAkeLktqeZyJoz1', NULL, 'home-active.png', 'normal', '2020-07-17 14:31:07', NULL);
INSERT INTO `image` VALUES ('15949731221801977b', NULL, 'http://qdlmtopf1.bkt.clouddn.com/9c598a0c7640f2a0f401cc44202dde71.jpg', NULL, 'FopbyudNhv-rXnrkMbdgKqF6way_', NULL, 'WechatIMG4.jpg', 'normal', '2020-07-17 16:05:22', NULL);
INSERT INTO `image` VALUES ('15950347595353811e', NULL, 'http://qdlmtopf1.bkt.clouddn.com/3873475eeecc3dd57054c429efba4774.png', NULL, 'FieZ3zTgrMNyhyAHeNKoo0Ladn8V', NULL, 'icon-userinfo.png', 'normal', '2020-07-18 09:12:39', NULL);
INSERT INTO `image` VALUES ('1595035152158f4792', NULL, 'http://qdlmtopf1.bkt.clouddn.com/cd2ef19d6dd6ac72de2518ccf41bc8df.png', NULL, 'Fj6b8KKjT6MlBiY_C7jaY24Etj6M', NULL, 'icon-kc.png', 'normal', '2020-07-18 09:19:12', NULL);
INSERT INTO `image` VALUES ('15950355808245ebf6', NULL, 'http://qdlmtopf1.bkt.clouddn.com/53b3c779f134c2f29e2d2c1536db99cc.png', NULL, 'Fj6b8KKjT6MlBiY_C7jaY24Etj6M', NULL, 'icon-kc.png', 'normal', '2020-07-18 09:26:20', NULL);
INSERT INTO `image` VALUES ('15950356002499c638', NULL, 'http://qdlmtopf1.bkt.clouddn.com/e4ae89ba0b97e1cf823e7c6ed54e6a99.png', NULL, 'Fl0OIuDy-eW24xWsuYotni_d5q8f', NULL, 'edit.png', 'normal', '2020-07-18 09:26:40', NULL);
INSERT INTO `image` VALUES ('159503561791758106', NULL, 'http://qdlmtopf1.bkt.clouddn.com/fb5fb80c51072af2c2bfebfba9fcc01b.png', NULL, 'FoGh79L8z9_8ApCXI_sMvc7dJMw3', NULL, 'filter.png', 'normal', '2020-07-18 09:26:57', NULL);
INSERT INTO `image` VALUES ('15950356698350d4ea', NULL, 'http://qdlmtopf1.bkt.clouddn.com/eade8c49635facb1cd823ff43eaa71ba.png', NULL, 'FieZ3zTgrMNyhyAHeNKoo0Ladn8V', NULL, 'icon-userinfo.png', 'normal', '2020-07-18 09:27:49', NULL);
INSERT INTO `image` VALUES ('1595035747737ed446', NULL, 'http://qdlmtopf1.bkt.clouddn.com/4f42a9e1e7bb392228ff0eee536fb5e5.png', NULL, 'FoGh79L8z9_8ApCXI_sMvc7dJMw3', NULL, 'filter.png', 'normal', '2020-07-18 09:29:07', NULL);
INSERT INTO `image` VALUES ('15950358014771571c', NULL, 'http://qdlmtopf1.bkt.clouddn.com/43049f6a31d3a2061299fda47886e82a.png', NULL, 'FieZ3zTgrMNyhyAHeNKoo0Ladn8V', NULL, 'icon-userinfo.png', 'normal', '2020-07-18 09:30:01', NULL);
INSERT INTO `image` VALUES ('1595036020073906ad', NULL, 'http://qdlmtopf1.bkt.clouddn.com/79fe3dbcf5dc6d86a14962452dfe3280.png', NULL, 'FieZ3zTgrMNyhyAHeNKoo0Ladn8V', NULL, 'icon-userinfo.png', 'normal', '2020-07-18 09:33:40', NULL);
INSERT INTO `image` VALUES ('1595036035687a9d58', NULL, 'http://qdlmtopf1.bkt.clouddn.com/4fe18a03393d666ed5b820c6e6ede21b.png', NULL, 'FoGh79L8z9_8ApCXI_sMvc7dJMw3', NULL, 'filter.png', 'normal', '2020-07-18 09:33:55', NULL);
INSERT INTO `image` VALUES ('15950364287512455a', NULL, 'http://qdlmtopf1.bkt.clouddn.com/fa9b87e204498d360fa73240b56cfbae.png', NULL, 'FhZwLX61Df2xxm8z_KRHWdPEX5cp', NULL, 'arrow.png', 'normal', '2020-07-18 09:40:28', NULL);
INSERT INTO `image` VALUES ('15952155940065921f', NULL, 'http://qdlmtopf1.bkt.clouddn.com/320fed62d3d31afad32bbd13d9902d17.png', NULL, 'Fj7iA-xxrmXGOtsybETt71URRZsv', NULL, 'error.png', 'normal', '2020-07-20 11:26:34', NULL);
INSERT INTO `image` VALUES ('159521993081760b01', NULL, 'http://qdlmtopf1.bkt.clouddn.com/7bfffa3ed9f5664b439863c9a2c100dc.png', NULL, 'FvAGg5SjMdFhSGPRVxpUOh1QyOvz', NULL, 'eye.png', 'normal', '2020-07-20 12:38:50', NULL);
INSERT INTO `image` VALUES ('159522013092913488', NULL, 'http://qdlmtopf1.bkt.clouddn.com/907d5b8bf787fb45e19abbdadbf459b5.png', NULL, 'FvAGg5SjMdFhSGPRVxpUOh1QyOvz', NULL, 'eye.png', 'normal', '2020-07-20 12:42:10', NULL);
INSERT INTO `image` VALUES ('15952205213882b4d4', NULL, 'http://qdlmtopf1.bkt.clouddn.com/d13d6a2c9516950ed09a5c121f23fae6.png', NULL, 'FvAGg5SjMdFhSGPRVxpUOh1QyOvz', NULL, 'eye.png', 'normal', '2020-07-20 12:48:41', NULL);
INSERT INTO `image` VALUES ('1595220731812710df', NULL, 'http://qdlmtopf1.bkt.clouddn.com/f4c9cd29d573eccbcaa6da3df539aa77.png', NULL, 'Fl0OIuDy-eW24xWsuYotni_d5q8f', NULL, 'edit.png', 'normal', '2020-07-20 12:52:11', NULL);
INSERT INTO `image` VALUES ('159522144563668bbe', NULL, 'http://qdlmtopf1.bkt.clouddn.com/c196644c75b22741e1103638fc656413.png', NULL, 'FoGh79L8z9_8ApCXI_sMvc7dJMw3', NULL, 'filter.png', 'normal', '2020-07-20 13:04:05', NULL);
INSERT INTO `image` VALUES ('15952215297580bfa1', NULL, 'http://qdlmtopf1.bkt.clouddn.com/68efcec0d447f7f6b67c87297ae91ac9.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-20 13:05:29', NULL);
INSERT INTO `image` VALUES ('15952233481276ad6e', NULL, 'http://qdlmtopf1.bkt.clouddn.com/35fd26852f8f33dee0b4bf49e16aec9c.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-20 13:35:48', NULL);
INSERT INTO `image` VALUES ('15952251049620157c', NULL, 'http://qdlmtopf1.bkt.clouddn.com/9d91e1c61e595374c5c2fecb7dd8c3ec.png', NULL, 'FktFhv9BboGPuqKxnQCyCA_HJ-sa', NULL, 'question-banner.png', 'normal', '2020-07-20 14:05:05', NULL);
INSERT INTO `image` VALUES ('1595322789900413d1', NULL, 'http://qdlmtopf1.bkt.clouddn.com/e0b590691537218dcbeff887cdcb70f1.png', NULL, 'Fj7iA-xxrmXGOtsybETt71URRZsv', NULL, 'error.png', 'normal', '2020-07-21 17:13:09', NULL);
INSERT INTO `image` VALUES ('1595385090006be7ae', NULL, 'http://qdlmtopf1.bkt.clouddn.com/a18aa6c651d9ef38e75b399d2d4f711b.jpg', NULL, 'FgqH0X3tNGntUMwFX-8JLhPgyb3X', NULL, 'wallhaven-yjr2z7.jpg', 'normal', '2020-07-22 10:31:30', NULL);
INSERT INTO `image` VALUES ('1595389427974e019c', NULL, 'http://qdlmtopf1.bkt.clouddn.com/f99d363957f8ca871c7ffcb20d38af4e.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 11:43:48', NULL);
INSERT INTO `image` VALUES ('1595389894095a7cd1', NULL, 'http://qdlmtopf1.bkt.clouddn.com/6c3e0ae39c83bf86d6cb6fb3dfb1eac7.png', NULL, 'Fj7iA-xxrmXGOtsybETt71URRZsv', NULL, 'error.png', 'normal', '2020-07-22 11:51:34', NULL);
INSERT INTO `image` VALUES ('1595390139122064da', NULL, 'http://qdlmtopf1.bkt.clouddn.com/2e6e6d9c2e0fd30341f7ef0cda689032.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 11:55:39', NULL);
INSERT INTO `image` VALUES ('159540156355285324', NULL, 'http://qdlmtopf1.bkt.clouddn.com/ec9217b4853c6cce2f62571182c72098.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 15:06:03', NULL);
INSERT INTO `image` VALUES ('1595401693452571ba', NULL, 'http://qdlmtopf1.bkt.clouddn.com/9e768c6e57ddf48105245a79c7bf8477.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 15:08:13', NULL);
INSERT INTO `image` VALUES ('15954017453825002e', NULL, 'http://qdlmtopf1.bkt.clouddn.com/a753093f72a349682cc43650866c8b24.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 15:09:05', NULL);
INSERT INTO `image` VALUES ('1595401789492ac7b0', NULL, 'http://qdlmtopf1.bkt.clouddn.com/fac7dcd9f69d71a4793eb443c9549afb.jpg', NULL, 'FnwxDiy0NBRhZvcIyxjL2h_0Uwgy', NULL, 'b_kc.png', 'normal', '2020-07-22 15:09:49', NULL);
INSERT INTO `image` VALUES ('15954019034863bcd0', NULL, 'http://qdlmtopf1.bkt.clouddn.com/e125cb2dd29fcf1beb06718779406eb4.png', NULL, 'Fj7iA-xxrmXGOtsybETt71URRZsv', NULL, 'error.png', 'normal', '2020-07-22 15:11:43', NULL);
INSERT INTO `image` VALUES ('15957319272391ffb7', NULL, 'http://qdlmtopf1.bkt.clouddn.com/b5e6cf9705b41994c2de0a9b938da099.png', NULL, 'FkFh8zgXSx1ORa7Z2UuKKl-wkDaB', NULL, '调拨房源.png', 'normal', '2020-07-26 10:52:07', NULL);
INSERT INTO `image` VALUES ('159583142083897857', NULL, '/resources/**', NULL, NULL, '2020-07-27 14:30:21', 'wallhaven-yjr2z7.jpg', 'normal', '2020-07-27 14:30:20', NULL);
INSERT INTO `image` VALUES ('15958315532770c0c5', NULL, '/resources//Users/jane/Downloads/file/wallhaven-yjr2z7.jpg', NULL, NULL, '2020-07-27 14:32:33', 'wallhaven-yjr2z7.jpg', 'normal', '2020-07-27 14:32:33', NULL);
INSERT INTO `image` VALUES ('1595831626370d5466', NULL, '/resources/wallhaven-yjr2z7.jpg', NULL, NULL, '2020-07-27 14:33:46', 'wallhaven-yjr2z7.jpg', 'normal', '2020-07-27 14:33:46', NULL);
INSERT INTO `image` VALUES ('1595832233797c4c3b', NULL, '/resources/wallhaven-yjr2z7.jpg', NULL, NULL, '2020-07-27 14:43:54', 'wallhaven-yjr2z7.jpg', 'normal', '2020-07-27 14:43:53', NULL);
INSERT INTO `image` VALUES ('159589730941164440', NULL, '/resources/藏器于身, 待时而动.png', NULL, NULL, '2020-07-28 08:48:29', '藏器于身, 待时而动.png', 'normal', '2020-07-28 08:48:29', NULL);
INSERT INTO `image` VALUES ('159591256623791bca', NULL, 'http://qdlmtopf1.bkt.clouddn.com/d842b664bb70e847fc7405a4dd172610.jpg', NULL, 'FtR19FZafsWQIcP5xWzBm740W5F8', NULL, 'logo_05.jpg', 'normal', '2020-07-28 13:02:46', NULL);
INSERT INTO `image` VALUES ('159641865127925162', NULL, '/resources/微信图片_20200707101413.jpg', NULL, NULL, '2020-08-03 09:37:31', '微信图片_20200707101413.jpg', 'normal', '2020-08-03 09:37:31', NULL);
INSERT INTO `image` VALUES ('1596418898979b126e', NULL, '/resources/微信图片_20200707152832.jpg', NULL, NULL, '2020-08-03 09:41:39', '微信图片_20200707152832.jpg', 'normal', '2020-08-03 09:41:39', NULL);
INSERT INTO `image` VALUES ('159641892008496f46', NULL, '/resources/微信图片_20200707152826.jpg', NULL, NULL, '2020-08-03 09:42:00', '微信图片_20200707152826.jpg', 'normal', '2020-08-03 09:42:00', NULL);
INSERT INTO `image` VALUES ('15964190185795ac76', NULL, '/resources/管泽元和余霜和平分手.jpeg', NULL, NULL, '2020-08-03 09:43:39', '管泽元和余霜和平分手.jpeg', 'normal', '2020-08-03 09:43:38', NULL);
INSERT INTO `image` VALUES ('1596420177582d7bbc', NULL, '/resources/logo_05.jpg', NULL, NULL, '2020-08-03 10:02:58', 'logo_05.jpg', 'normal', '2020-08-03 10:02:57', NULL);
INSERT INTO `image` VALUES ('1596421706061fba9d', NULL, '/resources/微信图片_20200707101413.jpg', NULL, NULL, '2020-08-03 10:28:26', '微信图片_20200707101413.jpg', 'normal', '2020-08-03 10:28:26', NULL);
INSERT INTO `image` VALUES ('1596421910323b67ed', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:31:50', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:31:50', NULL);
INSERT INTO `image` VALUES ('159642193111339d9a', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:32:11', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:32:11', NULL);
INSERT INTO `image` VALUES ('1596421953813c558f', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:32:34', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:32:33', NULL);
INSERT INTO `image` VALUES ('1596422190716358e0', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:36:31', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:36:30', NULL);
INSERT INTO `image` VALUES ('1596422242420ff5fe', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:37:22', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:37:22', NULL);
INSERT INTO `image` VALUES ('159642270936086aa7', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:45:09', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:45:09', NULL);
INSERT INTO `image` VALUES ('1596423331873cdbb9', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:55:32', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:55:31', NULL);
INSERT INTO `image` VALUES ('1596423392333e386d', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:56:32', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:56:32', NULL);
INSERT INTO `image` VALUES ('15964234153193452d', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 10:56:55', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 10:56:55', NULL);
INSERT INTO `image` VALUES ('1596429031122a62bc', NULL, '/resources/logo.png', NULL, NULL, '2020-08-03 12:30:31', 'logo.png', 'normal', '2020-08-03 12:30:31', NULL);
INSERT INTO `image` VALUES ('15964335142551ef41', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 13:45:14', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 13:45:14', NULL);
INSERT INTO `image` VALUES ('15964337836615117e', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-03 13:49:44', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-03 13:49:43', NULL);
INSERT INTO `image` VALUES ('15964338157221283b', NULL, '/resources/微信图片_20200707101413.jpg', NULL, NULL, '2020-08-03 13:50:16', '微信图片_20200707101413.jpg', 'normal', '2020-08-03 13:50:15', NULL);
INSERT INTO `image` VALUES ('159643415933176e86', NULL, 'http://qdlmtopf1.bkt.clouddn.com/f6378346c90af01fd998aec86a34ddae.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-03 13:55:59', NULL);
INSERT INTO `image` VALUES ('15964345458318879c', NULL, 'http://qdlmtopf1.bkt.clouddn.com/1e908d58d1417deedf4630f6e1b2202a.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-03 14:02:25', NULL);
INSERT INTO `image` VALUES ('15964391063661c410', NULL, 'http://qdlmtopf1.bkt.clouddn.com/0e1ed21547caca8db247c8d04275196d.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-03 15:18:26', NULL);
INSERT INTO `image` VALUES ('159650890045429ebf', NULL, 'http://qdlmtopf1.bkt.clouddn.com/53c93e229ddf2f03ed0ef217f71e3909.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 10:41:40', NULL);
INSERT INTO `image` VALUES ('1596509001126a9b4d', NULL, 'http://qdlmtopf1.bkt.clouddn.com/1df01fbfb48403995e53d995c919a88d.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 10:43:21', NULL);
INSERT INTO `image` VALUES ('15965090885212a9f7', NULL, 'http://qdlmtopf1.bkt.clouddn.com/9937995ec06563cf4ac2a9141ad8c669.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 10:44:48', NULL);
INSERT INTO `image` VALUES ('1596520094059dc9e5', NULL, 'http://qdlmtopf1.bkt.clouddn.com/296e5ddd88da7106a160764467e47f49.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 13:48:14', NULL);
INSERT INTO `image` VALUES ('159652027836368065', NULL, 'http://qdlmtopf1.bkt.clouddn.com/3bff427d1af932912fc5f9f4aa2ef140.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 13:51:18', NULL);
INSERT INTO `image` VALUES ('159652031357235c22', NULL, 'http://qdlmtopf1.bkt.clouddn.com/b1ebbdf8ee93e7203b6e1f4dfa1c5bd6.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 13:51:53', NULL);
INSERT INTO `image` VALUES ('1596521255044627b7', NULL, 'http://qdlmtopf1.bkt.clouddn.com/6db368576f94b440a9d28a2c575b8af4.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 14:07:35', NULL);
INSERT INTO `image` VALUES ('159652127696377e9f', NULL, 'http://qdlmtopf1.bkt.clouddn.com/3ed6d4092f9d14b6ffd198745540a54b.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 14:07:57', NULL);
INSERT INTO `image` VALUES ('1596529570732dd131', NULL, 'http://qdlmtopf1.bkt.clouddn.com/18eea5cfdc2733106e695fddfb137e17.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 16:26:10', NULL);
INSERT INTO `image` VALUES ('1596530707396962ca', NULL, 'http://qdlmtopf1.bkt.clouddn.com/1ca9ba103c651dba1f52317a325427b5.gif', NULL, 'Fk-FbH1axkqmd8ePyiUkS86XJoUz', NULL, '500133.gif', 'normal', '2020-08-04 16:45:07', NULL);
INSERT INTO `image` VALUES ('15965308297115b6b4', NULL, 'http://qdlmtopf1.bkt.clouddn.com/4c0b6bca3c08249ff23f6168dd5afe2e.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-04 16:47:09', NULL);
INSERT INTO `image` VALUES ('15966180206484d4e2', NULL, 'http://qdlmtopf1.bkt.clouddn.com/29b9f92032dbd5682f13604db962099f.png', NULL, 'Fs-qdCoObJea1O_3j6Y8FEhLyZF7', NULL, '藏器于身, 待时而动.png', 'normal', '2020-08-05 17:00:20', NULL);
INSERT INTO `image` VALUES ('1596682200776b50b8', NULL, 'http://qdlmtopf1.bkt.clouddn.com/e540cf563016cde18718d35abfe89a51.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-06 10:50:00', NULL);
INSERT INTO `image` VALUES ('1596694092949f953f', NULL, '/resources/%E7%AC%AC2020.8.3%E6%89%B9%E6%AC%A1-%E5%BE%85%E5%AE%89%E7%BD%AE%E6%88%B7%E4%B8%BB%E4%BF%A1%E6%81%AF (1).xlsx', NULL, NULL, '2020-08-06 14:08:13', '%E7%AC%AC2020.8.3%E6%89%B9%E6%AC%A1-%E5%BE%85%E5%AE%89%E7%BD%AE%E6%88%B7%E4%B8%BB%E4%BF%A1%E6%81%AF (1).xlsx', 'normal', '2020-08-06 14:08:12', NULL);
INSERT INTO `image` VALUES ('159669750005191dac', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-06 15:05:00', '0000.jpg', 'normal', '2020-08-06 15:05:00', NULL);
INSERT INTO `image` VALUES ('15966987342306d5cb', NULL, 'http://qdlmtopf1.bkt.clouddn.com/33c8bd266259722e3d4e42f36920b01a.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-06 15:25:34', NULL);
INSERT INTO `image` VALUES ('15967639719689b578', NULL, '/resources/u=1855124263,501616481&fm=26&gp=0.jpg', NULL, NULL, '2020-08-07 09:32:52', 'u=1855124263,501616481&fm=26&gp=0.jpg', 'normal', '2020-08-07 09:32:52', NULL);
INSERT INTO `image` VALUES ('1597030411833e1ae6', NULL, '/resources/icon-zs.a3f66d05.png', NULL, NULL, '2020-08-10 11:33:32', 'icon-zs.a3f66d05.png', 'normal', '2020-08-10 11:33:31', NULL);
INSERT INTO `image` VALUES ('1597030542464d0d3d', NULL, '/resources/form-a.png', NULL, NULL, '2020-08-10 11:35:42', 'form-a.png', 'normal', '2020-08-10 11:35:42', NULL);
INSERT INTO `image` VALUES ('159703065570616898', NULL, '/resources/icon-promise.png', NULL, NULL, '2020-08-10 11:37:36', 'icon-promise.png', 'normal', '2020-08-10 11:37:35', NULL);
INSERT INTO `image` VALUES ('15971068188502adbd', NULL, '/resources/seckill.png', NULL, NULL, '2020-08-11 08:46:59', 'seckill.png', 'normal', '2020-08-11 08:46:58', NULL);
INSERT INTO `image` VALUES ('159711359530019d14', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-11 10:39:55', '0000.jpg', 'normal', '2020-08-11 10:39:55', NULL);
INSERT INTO `image` VALUES ('1597113609135e5365', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-11 10:40:09', '0000.jpg', 'normal', '2020-08-11 10:40:09', NULL);
INSERT INTO `image` VALUES ('15971136166046209c', NULL, '/resources/1164515.gif', NULL, NULL, '2020-08-11 10:40:17', '1164515.gif', 'normal', '2020-08-11 10:40:16', NULL);
INSERT INTO `image` VALUES ('15971275370927a47e', NULL, 'http://qdlmtopf1.bkt.clouddn.com/ff4e819b8006b2513a3c7027eca7be00.jpg', NULL, 'FthMVuB-pesvq8bW9PVyrwDDRhPq', NULL, '0000.jpg', 'normal', '2020-08-11 14:32:17', NULL);
INSERT INTO `image` VALUES ('1597193906241ed1e1', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 08:58:26', '0000.jpg', 'normal', '2020-08-12 08:58:26', NULL);
INSERT INTO `image` VALUES ('159719428106923956', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:04:41', '0000.jpg', 'normal', '2020-08-12 09:04:41', NULL);
INSERT INTO `image` VALUES ('15971954417563b425', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:24:02', '0000.jpg', 'normal', '2020-08-12 09:24:01', NULL);
INSERT INTO `image` VALUES ('1597195449330131b9', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:24:09', '0000.jpg', 'normal', '2020-08-12 09:24:09', NULL);
INSERT INTO `image` VALUES ('1597195531621b185a', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:25:32', '0000.jpg', 'normal', '2020-08-12 09:25:31', NULL);
INSERT INTO `image` VALUES ('15971957141686e827', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:28:34', '0000.jpg', 'normal', '2020-08-12 09:28:34', NULL);
INSERT INTO `image` VALUES ('1597195948978ab4c3', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:32:29', '0000.jpg', 'normal', '2020-08-12 09:32:29', NULL);
INSERT INTO `image` VALUES ('1597195992583e3be1', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:33:13', '0000.jpg', 'normal', '2020-08-12 09:33:12', NULL);
INSERT INTO `image` VALUES ('1597196058084d0d3d', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:34:18', '0000.jpg', 'normal', '2020-08-12 09:34:18', NULL);
INSERT INTO `image` VALUES ('15971962943038088c', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:38:14', '0000.jpg', 'normal', '2020-08-12 09:38:14', NULL);
INSERT INTO `image` VALUES ('1597196321094ae217', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:38:41', '0000.jpg', 'normal', '2020-08-12 09:38:41', NULL);
INSERT INTO `image` VALUES ('1597196360818c55d0', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:39:21', '0000.jpg', 'normal', '2020-08-12 09:39:20', NULL);
INSERT INTO `image` VALUES ('15971963673757d797', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:39:27', '0000.jpg', 'normal', '2020-08-12 09:39:27', NULL);
INSERT INTO `image` VALUES ('1597196406292b5b0e', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:40:06', '0000.jpg', 'normal', '2020-08-12 09:40:06', NULL);
INSERT INTO `image` VALUES ('1597196425173e799d', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:40:25', '0000.jpg', 'normal', '2020-08-12 09:40:25', NULL);
INSERT INTO `image` VALUES ('15971964475737de4a', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:40:48', '0000.jpg', 'normal', '2020-08-12 09:40:47', NULL);
INSERT INTO `image` VALUES ('1597196476195e7734', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:41:16', '0000.jpg', 'normal', '2020-08-12 09:41:16', NULL);
INSERT INTO `image` VALUES ('1597196505413c498d', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:41:45', '0000.jpg', 'normal', '2020-08-12 09:41:45', NULL);
INSERT INTO `image` VALUES ('15971965761345c407', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:42:56', '0000.jpg', 'normal', '2020-08-12 09:42:56', NULL);
INSERT INTO `image` VALUES ('15971966884045cf31', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:44:48', '0000.jpg', 'normal', '2020-08-12 09:44:48', NULL);
INSERT INTO `image` VALUES ('159719669635921068', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:44:56', '0000.jpg', 'normal', '2020-08-12 09:44:56', NULL);
INSERT INTO `image` VALUES ('1597196729762c3b20', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:45:30', '0000.jpg', 'normal', '2020-08-12 09:45:29', NULL);
INSERT INTO `image` VALUES ('1597196916457058a2', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:48:36', '0000.jpg', 'normal', '2020-08-12 09:48:36', NULL);
INSERT INTO `image` VALUES ('15971969213757d8ec', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:48:41', '0000.jpg', 'normal', '2020-08-12 09:48:41', NULL);
INSERT INTO `image` VALUES ('15971969401187e4c9', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:49:00', '0000.jpg', 'normal', '2020-08-12 09:49:00', NULL);
INSERT INTO `image` VALUES ('1597196988954f4e59', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:49:49', '0000.jpg', 'normal', '2020-08-12 09:49:48', NULL);
INSERT INTO `image` VALUES ('15971970214733c7c1', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:50:21', '0000.jpg', 'normal', '2020-08-12 09:50:21', NULL);
INSERT INTO `image` VALUES ('159719703248090f6d', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:50:32', '0000.jpg', 'normal', '2020-08-12 09:50:32', NULL);
INSERT INTO `image` VALUES ('15971971974262f504', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:53:17', '0000.jpg', 'normal', '2020-08-12 09:53:17', NULL);
INSERT INTO `image` VALUES ('15971972221279ee4a', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:53:42', '0000.jpg', 'normal', '2020-08-12 09:53:42', NULL);
INSERT INTO `image` VALUES ('1597197343469ab1e3', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:55:43', '0000.jpg', 'normal', '2020-08-12 09:55:43', '2020-08-12 09:55:44');
INSERT INTO `image` VALUES ('159719742459720e0e', NULL, '/resources/1164430.gif', NULL, NULL, '2020-08-12 09:57:05', '1164430.gif', 'normal', '2020-08-12 09:57:04', NULL);
INSERT INTO `image` VALUES ('1597197446466afce6', '3b2ed1cff3e34949818479c85ff250f2', '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:57:26', '0000.jpg', 'normal', '2020-08-12 09:57:26', '2020-08-12 09:57:27');
INSERT INTO `image` VALUES ('1597197464525b52b0', '12792e0596aa436aa04db6cc7e91c4fc', '/resources/0000.jpg', NULL, NULL, '2020-08-12 09:57:45', '0000.jpg', 'normal', '2020-08-12 09:57:44', '2020-08-12 09:58:04');
INSERT INTO `image` VALUES ('1597197482320b45c9', 'e8f72da73b574fc78dd1e10badfbc815', '/resources/timg.jpeg', NULL, NULL, '2020-08-12 09:58:02', 'timg.jpeg', 'normal', '2020-08-12 09:58:02', '2020-08-12 09:58:04');
INSERT INTO `image` VALUES ('1597210883930f6e8e', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 13:41:24', '0000.jpg', 'normal', '2020-08-12 13:41:23', NULL);
INSERT INTO `image` VALUES ('15972109035220cea0', NULL, '/resources/timg.jpeg', NULL, NULL, '2020-08-12 13:41:44', 'timg.jpeg', 'normal', '2020-08-12 13:41:43', NULL);
INSERT INTO `image` VALUES ('15972109254084a5b8', 'b5674398b58043f4a4f53d593de9b9a6', '/resources/0000.jpg', NULL, NULL, '2020-08-12 13:42:05', '0000.jpg', 'normal', '2020-08-12 13:42:05', '2020-08-12 13:42:12');
INSERT INTO `image` VALUES ('159721093132810c91', '0b83351d74a248758a34fe3e988c7f87', '/resources/timg.jpeg', NULL, NULL, '2020-08-12 13:42:11', 'timg.jpeg', 'normal', '2020-08-12 13:42:11', '2020-08-12 13:42:13');
INSERT INTO `image` VALUES ('15972111283921ae2b', '03724be6da044253882623b75fca226d', '/resources/0000.jpg', NULL, NULL, '2020-08-12 13:45:28', '0000.jpg', 'normal', '2020-08-12 13:45:28', '2020-08-12 13:45:31');
INSERT INTO `image` VALUES ('15972115270166e34c', 'c1a18b94ccfb402681c95bdda914a61e', '/resources/0000.jpg', NULL, NULL, '2020-08-12 13:52:07', '0000.jpg', 'normal', '2020-08-12 13:52:07', '2020-08-12 13:52:08');
INSERT INTO `image` VALUES ('15972120070114ae64', 'c1a18b94ccfb402681c95bdda914a61e', '/resources/0000.jpg', NULL, NULL, '2020-08-12 14:00:07', '0000.jpg', 'normal', '2020-08-12 14:00:07', '2020-08-12 14:00:11');
INSERT INTO `image` VALUES ('15972183358946c3bd', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:45:36', '0000.jpg', 'normal', '2020-08-12 15:45:35', NULL);
INSERT INTO `image` VALUES ('1597218349479d76db', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:45:49', '0000.jpg', 'normal', '2020-08-12 15:45:49', NULL);
INSERT INTO `image` VALUES ('159721850206625cae', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:48:22', '0000.jpg', 'normal', '2020-08-12 15:48:22', NULL);
INSERT INTO `image` VALUES ('15972185083438f73b', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:48:28', '0000.jpg', 'normal', '2020-08-12 15:48:28', NULL);
INSERT INTO `image` VALUES ('159721859057029ddf', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:49:51', '0000.jpg', 'normal', '2020-08-12 15:49:50', NULL);
INSERT INTO `image` VALUES ('1597218596007c81eb', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:49:56', '0000.jpg', 'normal', '2020-08-12 15:49:56', NULL);
INSERT INTO `image` VALUES ('159721860128334dc0', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:50:01', '0000.jpg', 'normal', '2020-08-12 15:50:01', NULL);
INSERT INTO `image` VALUES ('159721863412057305', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:50:34', '0000.jpg', 'normal', '2020-08-12 15:50:34', NULL);
INSERT INTO `image` VALUES ('1597218638738ef51f', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:50:39', '0000.jpg', 'normal', '2020-08-12 15:50:38', NULL);
INSERT INTO `image` VALUES ('1597218682518a66bc', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:51:23', '0000.jpg', 'normal', '2020-08-12 15:51:22', NULL);
INSERT INTO `image` VALUES ('159721868890459385', NULL, '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:51:29', '0000.jpg', 'normal', '2020-08-12 15:51:28', NULL);
INSERT INTO `image` VALUES ('1597218697506ee3c5', '3a36e072725a4d9f90c7f6f75bc62cfc', '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:51:38', '0000.jpg', 'normal', '2020-08-12 15:51:37', '2020-08-12 15:51:47');
INSERT INTO `image` VALUES ('1597218701773f5a65', '25afafaa7ea640db971f61ed3897a137', '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:51:42', '0000.jpg', 'normal', '2020-08-12 15:51:41', '2020-08-12 15:51:47');
INSERT INTO `image` VALUES ('159721870603872aff', 'e271d444ad13409692316d07ddf6fa16', '/resources/0000.jpg', NULL, NULL, '2020-08-12 15:51:46', '0000.jpg', 'normal', '2020-08-12 15:51:46', '2020-08-12 15:51:47');
INSERT INTO `image` VALUES ('1597280805772bdf59', '3a36e072725a4d9f90c7f6f75bc62cfc', '/resources/timg.jpeg', NULL, NULL, '2020-08-13 09:06:46', 'timg.jpeg', 'normal', '2020-08-13 09:06:45', '2020-08-13 09:06:47');
INSERT INTO `image` VALUES ('15972811139926c293', 'e271d444ad13409692316d07ddf6fa16', '/resources/timg.jpeg', NULL, NULL, '2020-08-13 09:11:54', 'timg.jpeg', 'normal', '2020-08-13 09:11:54', '2020-08-13 09:11:55');
INSERT INTO `image` VALUES ('15972873976795dd53', 'e6fb4e2633e644b1b8b31e0464949853', '/resources/0000.jpg', NULL, NULL, '2020-08-13 10:56:38', '0000.jpg', 'normal', '2020-08-13 10:56:37', '2020-08-13 10:56:39');
INSERT INTO `image` VALUES ('1597287912778bf938', 'eb60cae33e0e4b1fb4ce2ce8769ccbd5', '/resources/0000.jpg', NULL, NULL, '2020-08-13 11:05:13', '0000.jpg', 'normal', '2020-08-13 11:05:12', '2020-08-13 11:05:18');
INSERT INTO `image` VALUES ('159728791615136457', '4d4033c332244472b5e09c9588d8fb82', '/resources/0000.jpg', NULL, NULL, '2020-08-13 11:05:16', '0000.jpg', 'normal', '2020-08-13 11:05:16', '2020-08-13 11:05:18');
INSERT INTO `image` VALUES ('15973965682754dd77', '81aa64fcd4e447f6bcffdc1fc7e6dfff', '/resources/0000.jpg', NULL, NULL, '2020-08-14 17:16:08', '0000.jpg', 'normal', '2020-08-14 17:16:08', '2020-08-14 17:16:09');
INSERT INTO `image` VALUES ('159762486288804b40', 'c8f63150136d46f6b0a2e8152f634d8b', '/resources/0000.jpg', NULL, NULL, '2020-08-17 08:41:03', '0000.jpg', 'normal', '2020-08-17 08:41:02', '2020-08-17 08:41:04');
INSERT INTO `image` VALUES ('1597720004160a5d41', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:06:44', '0000.jpg', 'normal', '2020-08-18 11:06:44', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('159772000932248bb8', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:06:49', '0000.jpg', 'normal', '2020-08-18 11:06:49', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('15977200136729fda6', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:06:54', '0000.jpg', 'normal', '2020-08-18 11:06:53', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('1597720017432d9ed1', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:06:57', '0000.jpg', 'normal', '2020-08-18 11:06:57', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('15977200215003739c', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:02', '0000.jpg', 'normal', '2020-08-18 11:07:01', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('1597720026119fbeda', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:06', '0000.jpg', 'normal', '2020-08-18 11:07:06', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('159772002951282dc5', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:10', '0000.jpg', 'normal', '2020-08-18 11:07:09', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('15977200330190c751', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:13', '0000.jpg', 'normal', '2020-08-18 11:07:13', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('1597720036868be358', '72844975cb3b49faaa05ec60f55a048d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:17', '0000.jpg', 'normal', '2020-08-18 11:07:16', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('15977200403356e58a', '72844975cb3b49faaa05ec60f55a048d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:20', '0000.jpg', 'normal', '2020-08-18 11:07:20', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('1597720044659a08de', '72844975cb3b49faaa05ec60f55a048d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:25', '0000.jpg', 'normal', '2020-08-18 11:07:24', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('159772004926385180', 'e8294654bc4f47549e19c0a710c53cb4', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:29', '0000.jpg', 'normal', '2020-08-18 11:07:29', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('159772005338717032', 'e8294654bc4f47549e19c0a710c53cb4', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:33', '0000.jpg', 'normal', '2020-08-18 11:07:33', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('1597720057978ac104', 'e8294654bc4f47549e19c0a710c53cb4', '/resources/0000.jpg', NULL, NULL, '2020-08-18 11:07:38', '0000.jpg', 'normal', '2020-08-18 11:07:38', '2020-08-18 11:07:40');
INSERT INTO `image` VALUES ('159774308570614c50', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:31:26', '0000.jpg', 'normal', '2020-08-18 17:31:25', '2020-08-18 17:31:37');
INSERT INTO `image` VALUES ('15977430890683da3b', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:31:29', '0000.jpg', 'normal', '2020-08-18 17:31:29', '2020-08-18 17:31:37');
INSERT INTO `image` VALUES ('15977430923402b143', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:31:32', '0000.jpg', 'normal', '2020-08-18 17:31:32', '2020-08-18 17:31:37');
INSERT INTO `image` VALUES ('1597743095722252f0', 'e4434df7aee54ac29b4eeb61777be69d', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:31:36', '0000.jpg', 'normal', '2020-08-18 17:31:35', '2020-08-18 17:31:37');
INSERT INTO `image` VALUES ('159774312377788821', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:32:04', '0000.jpg', 'normal', '2020-08-18 17:32:03', '2020-08-18 17:32:33');
INSERT INTO `image` VALUES ('1597743127638a278d', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:32:08', '0000.jpg', 'normal', '2020-08-18 17:32:07', '2020-08-18 17:32:33');
INSERT INTO `image` VALUES ('15977431311143e22d', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/1附件2：17软件二班顶岗实习信息表（指导教师填写、专业负责人汇总）1.xls', NULL, NULL, '2020-08-18 17:32:11', '1附件2：17软件二班顶岗实习信息表（指导教师填写、专业负责人汇总）1.xls', 'normal', '2020-08-18 17:32:11', '2020-08-18 17:32:33');
INSERT INTO `image` VALUES ('1597743147840eccb5', 'f4057e38e7384ad689a4e73d1b07aa94', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:32:28', '0000.jpg', 'normal', '2020-08-18 17:32:27', '2020-08-18 17:32:33');
INSERT INTO `image` VALUES ('1597743181536a9985', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:33:02', '0000.jpg', 'normal', '2020-08-18 17:33:01', '2020-08-18 17:33:14');
INSERT INTO `image` VALUES ('159774318490954bab', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:33:05', '0000.jpg', 'normal', '2020-08-18 17:33:04', '2020-08-18 17:33:14');
INSERT INTO `image` VALUES ('1597743188021452ab', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:33:08', '0000.jpg', 'normal', '2020-08-18 17:33:08', '2020-08-18 17:33:14');
INSERT INTO `image` VALUES ('1597743191260099f2', 'e39ae442287d466e872636066f3c3aa8', '/resources/0000.jpg', NULL, NULL, '2020-08-18 17:33:11', '0000.jpg', 'normal', '2020-08-18 17:33:11', '2020-08-18 17:33:14');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, 'ROLE_ADMIN', '管理员', '管理员', 'normal');
INSERT INTO `role` VALUES (2, 'ROLE_USER', '用户', '用户', 'normal');
INSERT INTO `role` VALUES (10, 'ROLE_ADMIN_LV3', '普通管理员', '普通管理员', 'normal');
COMMIT;

-- ----------------------------
-- Table structure for role_admin_res
-- ----------------------------
DROP TABLE IF EXISTS `role_admin_res`;
CREATE TABLE `role_admin_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `role_res_id` int(11) DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of role_admin_res
-- ----------------------------
BEGIN;
INSERT INTO `role_admin_res` VALUES (319, 2, 1, '2020-06-19 13:48:14');
INSERT INTO `role_admin_res` VALUES (320, 10, 1, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (321, 10, 2, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (322, 10, 3, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (323, 10, 4, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (324, 10, 39, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (325, 10, 40, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (326, 10, 36, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (327, 10, 41, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (328, 10, 42, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (329, 10, 43, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (330, 10, 44, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (331, 10, 45, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (332, 10, 38, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (333, 10, 46, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (334, 10, 47, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (335, 10, 48, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (336, 10, 49, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (337, 10, 50, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (338, 10, 51, '2020-06-19 13:48:18');
INSERT INTO `role_admin_res` VALUES (379, 1, 1, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (380, 1, 52, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (381, 1, 2, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (382, 1, 3, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (383, 1, 4, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (384, 1, 39, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (385, 1, 40, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (386, 1, 36, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (387, 1, 41, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (388, 1, 42, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (389, 1, 43, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (390, 1, 44, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (391, 1, 45, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (392, 1, 38, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (393, 1, 46, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (394, 1, 47, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (395, 1, 48, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (396, 1, 49, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (397, 1, 50, '2020-06-21 00:06:39');
INSERT INTO `role_admin_res` VALUES (398, 1, 51, '2020-06-21 00:06:39');
COMMIT;

-- ----------------------------
-- Table structure for role_res
-- ----------------------------
DROP TABLE IF EXISTS `role_res`;
CREATE TABLE `role_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `r_id` int(11) NOT NULL DEFAULT '0',
  `url` text COLLATE utf8mb4_bin COMMENT '地址',
  `permission` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '路由名称',
  `url_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '资源名称',
  `type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类型',
  `status` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
  `icon` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色资源';

-- ----------------------------
-- Records of role_res
-- ----------------------------
BEGIN;
INSERT INTO `role_res` VALUES (1, 0, '/index', 'index', '首页', 'section', 'normal', '3c71124950534894d3e165d31f527820.png');
INSERT INTO `role_res` VALUES (2, 0, '/authorityManage', 'authorityManage', '权限管理', 'section', 'normal', '1870118df6a3b8adb5697e26b7849a09.png');
INSERT INTO `role_res` VALUES (3, 2, '/index/authorityManage/resource', 'authorityManageResource', '资源管理', 'page', 'normal', NULL);
INSERT INTO `role_res` VALUES (4, 3, '/api/app/auth_role_res/save', NULL, '资源添加OR更新', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (36, 2, '/index/authorityManage/role', 'authorityManageRole', '角色管理', 'page', 'normal', NULL);
INSERT INTO `role_res` VALUES (38, 2, '/index/authorityManage/user', 'authorityManageUser', '用户管理', 'page', 'normal', NULL);
INSERT INTO `role_res` VALUES (39, 3, '/api/app/auth_role_res/list', NULL, '资源列表', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (40, 3, '/api/app/auth_role_res/remove/{*}', NULL, '新增资源', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (41, 36, '/api/app/role/change/{*}', NULL, '改变角色状态', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (42, 36, '/api/app/role/list', NULL, '角色列表', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (43, 36, '/api/app/role/remove/{*}', NULL, '删除角色', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (44, 36, '/api/app/role/role_permissions/{*}', NULL, '通过角色ID获取对应的角色权限', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (45, 36, '/api/app/role/save', NULL, '添加 OR 更新', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (46, 38, '/api/app/admin/admin_APIinfo', NULL, '获取用户信息', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (47, 38, '/api/app/admin/change/{*}', NULL, '改变管理员状态', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (48, 38, '/api/app/admin/list', NULL, '获取管理员列表', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (49, 38, '/api/app/admin/remove/{*}', NULL, '删除管理员', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (50, 38, '/api/app/admin/reset_psd/{*}', NULL, '重置管理员密码', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (51, 38, '/api/app/admin/save', NULL, '添加 OR 更新管理员', 'interface', 'normal', NULL);
INSERT INTO `role_res` VALUES (52, 0, '/index/system', 'system', '系统设置', 'section', 'normal', '140cc7cf629b9e0edd558c6f4a130705.png');
COMMIT;

-- ----------------------------
-- Table structure for site
-- ----------------------------
DROP TABLE IF EXISTS `site`;
CREATE TABLE `site` (
  `key` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `remark` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='站点基本信息';

-- ----------------------------
-- Records of site
-- ----------------------------
BEGIN;
INSERT INTO `site` VALUES ('SITE_COPYRIGHT', '©2019-2020 滁州易搜科技', '版权信息', '2020-07-07 09:12:19', NULL);
INSERT INTO `site` VALUES ('SITE_FOOTER', '滁州易搜科技提供技术支持', '站点页脚信息', '2020-07-07 09:12:19', NULL);
INSERT INTO `site` VALUES ('SITE_NAME', '房屋拆迁安置后台管理', '站点名称', '2020-07-07 09:12:19', '2020-07-07 09:26:10');
INSERT INTO `site` VALUES ('WEBSITE_ADDRESS', 'http://czesou.com', '公司网址', '2020-07-10 09:54:26', NULL);
COMMIT;

-- ----------------------------
-- Table structure for uc_user
-- ----------------------------
DROP TABLE IF EXISTS `uc_user`;
CREATE TABLE `uc_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'femalemale',
  `id_no` varchar(128) DEFAULT NULL COMMENT '身份证信息',
  `phone` varchar(32) DEFAULT NULL COMMENT '手机号',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `work_address` varchar(128) DEFAULT NULL COMMENT '工作地址',
  `company` varchar(128) DEFAULT NULL COMMENT '公司',
  `source` varchar(32) DEFAULT NULL COMMENT '来源:微信注册',
  `status` varchar(32) NOT NULL DEFAULT 'normal' COMMENT '状态:normaldeleteddisable',
  `avatar_url` varchar(255) DEFAULT NULL,
  `wechat_openid` varchar(128) DEFAULT NULL COMMENT '微信openid',
  `third_id` varchar(128) DEFAULT NULL COMMENT '微信unionid',
  `enterprise_code` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `attr` varchar(1024) DEFAULT NULL COMMENT '拓展字段',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `area_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_phone` (`phone`) USING BTREE,
  UNIQUE KEY `uk_wechat_openid` (`wechat_openid`) USING BTREE,
  KEY `IDX_STATUS` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='用户信息';

-- ----------------------------
-- Records of uc_user
-- ----------------------------
BEGIN;
INSERT INTO `uc_user` VALUES (91, '醉微渺', '', NULL, NULL, NULL, '醉微渺', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DGSxrAJDIziaN8HZPE3Aq9a64GicocjSKCFRwoicgZaZ9u8aDAuJY3Y9HrGFFjLy1ZmUDDOyicpBnr5DhzAqODcyGicc/132', 'oRlwVxLs6q6RjtgyzS9g7FZvDpy8', NULL, NULL, NULL, NULL, '2020-06-09 16:32:35', '2020-06-09 16:32:35', NULL);
INSERT INTO `uc_user` VALUES (101, '陈凯旋', '男', NULL, '15255391553', NULL, '陈凯旋', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z0oS1kgib7xm7Ob0hib30z4uU9ianPOokTK7c1Az1nGnic8JNeVJHZtqWTnIb2KTlicLt164XXYqfUaqv9IMXricWGj48/132', 'oRlwVxLANuU_jR0cfQ4ZgCvW8INM', NULL, NULL, NULL, NULL, '2020-06-10 09:46:18', '2020-06-10 09:46:18', '340102');
INSERT INTO `uc_user` VALUES (112, 'small  fish', '男', NULL, '18256918475', NULL, 'small  fish', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DH6lVliagibBSDCbrpP69mU7hB9jchUOibv4ukky9icvhH9813jbF2vY5tCz9U9ZBaSPsGyYpBRWTtgShlf3ia9mf9UT/132', 'oRlwVxPiN-r6Oyttp4k3YHz89f9c', NULL, NULL, NULL, NULL, '2020-06-15 13:52:25', '2020-06-15 13:52:25', '340111');
INSERT INTO `uc_user` VALUES (118, '综艺秀', '女', NULL, '18226828015', NULL, '综艺秀', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/FzlSRt7HR21rxv2hiblFv0b51rd16tiblFs958aGEYmaAI0n21QicIXmZic6m5DOEKvlO7Iyib5QFhOfgZGpUgib9PH3mMRwxWGh9T/132', 'oRlwVxKqCQHdUunTk17okq_cdoWM', NULL, NULL, NULL, NULL, '2020-06-16 19:48:34', '2020-06-16 19:48:34', '340102');
INSERT INTO `uc_user` VALUES (120, 'Believe', '男', NULL, NULL, NULL, 'Believe', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/eytJa9K5jkrFKgxF61iayNQiaic66ykX21RcQWDe24ga9EGB7vLGGbyjKCerZB2qDRa97Y1j0icmsNoMqkSYJuERQQ/132', 'oRlwVxAt99gIgs9N-YQRrbrFNTs0', NULL, NULL, NULL, NULL, '2020-06-18 14:14:31', '2020-06-18 14:14:31', NULL);
INSERT INTO `uc_user` VALUES (121, '扎根先生', '男', NULL, NULL, NULL, '扎根先生', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z0oS1kgib7xm7FuUQj5erhTGG034PFSF41WshpmFAf24q7y4j1Tmic55ib6LBibzOtR7D21lXG7Qaj5bHaWRqhkjvWh/132', 'oRlwVxHcbKfHDfzRhgHr7O_zzYx4', NULL, NULL, NULL, NULL, '2020-06-18 15:48:59', '2020-06-18 15:48:59', NULL);
INSERT INTO `uc_user` VALUES (122, 'Jerry君恒', '男', NULL, NULL, NULL, 'Jerry君恒', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DGSxrAJDIziaNwAhEbbNSo1JqibzBoWzEHBib761TmR2r2eNTgKmDt1NZoicTkUJiaplCl9XpO35RQ3M9wPwgjLLKJaK/132', 'oRlwVxEA5TKM3Wdw12Ml5vkEOiJM', NULL, NULL, NULL, NULL, '2020-06-18 16:35:55', '2020-06-18 16:35:55', NULL);
INSERT INTO `uc_user` VALUES (123, '喜羊羊', '', NULL, NULL, NULL, '喜羊羊', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z0JTOaoYD7TupyXPILsJucKXpriaNsh0wdX98eouOtcsCr1DweWjZCAJxDjCgzUZxwaS0RZPfKegiag/132', 'oRlwVxEsmT1Q759sOMLmPJgG5qyQ', NULL, NULL, NULL, NULL, '2020-06-18 16:50:05', '2020-06-18 16:50:05', NULL);
INSERT INTO `uc_user` VALUES (126, 'W.X.', '男', NULL, NULL, NULL, 'W.X.', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DFcrTiahDwVjV55ksr485PpmrcR629SNVYm7ljQsWFepIYa7GchRdRVQr6Jy9NqcAISicnohiahmwuvicpNFuPdWGUy/132', 'oRlwVxERZvLZsuoPV8oNuvhmK1Xg', NULL, NULL, NULL, NULL, '2020-06-19 10:41:48', '2020-06-19 10:41:48', NULL);
INSERT INTO `uc_user` VALUES (127, 'lqdbs', '男', NULL, '15805600506', NULL, 'lqdbs', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/eytJa9K5jkqBibImfiaia0G81CWbZa3Le6wKrzgUTDFGfA0SLh3RtWK8Rfe9icalNZSFIXOLhg44B8qKEgycEvEGfqrezrbcjOIn/132', 'oRlwVxOALkIXjPDvDrUML1NGzUIE', NULL, NULL, NULL, NULL, '2020-06-19 10:56:23', '2020-06-19 10:56:23', '340102');
INSERT INTO `uc_user` VALUES (128, '大丹', '', NULL, NULL, NULL, '大丹', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/wx4icZOCLPSicicW69xxia7GBKWgFCOMKRJicfJASuBxUUAs7xWOicpKhdXukib4SES6Jz15b8OPHXPxH9ctTPAbiaBrgzc1sgVxfvg3/132', 'oRlwVxInNm3pVX1HRv-nvsV31Ef8', NULL, NULL, NULL, NULL, '2020-06-19 14:17:40', '2020-06-19 14:17:40', NULL);
INSERT INTO `uc_user` VALUES (129, '瑞居房产中介喻媛媛13505509531', '', NULL, NULL, NULL, '瑞居房产中介喻媛媛13505509531', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/FzlSRt7HR22ibU7GwdCFf0u0IDZw6BPC845G5pVm0bibt3qlxc3cRWWnNZxb3jVGbuevKGoJAokWIApELTB2oywct1o4H1lj1N/132', 'oRlwVxAmYysblT_Ef4yqayb7sDKU', NULL, NULL, NULL, NULL, '2020-06-20 11:35:50', '2020-06-20 11:35:50', NULL);
INSERT INTO `uc_user` VALUES (132, '欧阳（昱城食品）', '男', NULL, NULL, NULL, '欧阳（昱城食品）', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/wx4icZOCLPSicicW69xxia7GBHT8ibVRBeSPTJjmUOcuoXtSIxiayBWoZg62WQzB4SDw1B1FstP1hH6n5WbMmV55b92NyeHvP6419g/132', 'oRlwVxLhMVmTyT76fQrT12kN3Vg4', NULL, NULL, NULL, NULL, '2020-06-24 07:42:51', '2020-06-24 07:42:51', NULL);
INSERT INTO `uc_user` VALUES (135, '因吹斯汀', '男', NULL, NULL, NULL, '因吹斯汀', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DG5MD175EiaP9a4sc0icAX9M8vOGGkx3XSbibC9uc8aShXNicRreJ6mfWchCamib6spQJo49Xda2r0ods9pWuz7PWTMK/132', 'oRlwVxDvcjWZAlPGmPduj9_7qA80', NULL, NULL, NULL, NULL, '2020-07-06 17:19:03', '2020-07-06 17:19:03', NULL);
INSERT INTO `uc_user` VALUES (136, '易搜', '男', NULL, '15155005218', NULL, '易搜', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DGSxrAJDIziaN0G5VvRiaFjTSMPcT2yoMa3s6ayZnc8AHpMZBs4G3UBE5Ad9EgibNJ23HFLSXcKGoRGtWkSF2O4NsV/132', 'oRlwVxExxCrfHWM1x-T2ytyLZTO4', NULL, NULL, NULL, NULL, '2020-07-29 14:52:46', '2020-07-29 14:52:46', '');
INSERT INTO `uc_user` VALUES (137, '刘洋', '男', NULL, NULL, NULL, '刘洋', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z2EaBGUS0ymXwrYsibBVczzqk5ZgaFRmpUy4YHWm95DlcDPVaYZMnQyk3bnvuNwFhm6yWTBJdEh6RA/132', 'oRlwVxLKKzVqKlbW4Qb60-evoA-s', NULL, NULL, NULL, NULL, '2020-08-08 15:32:36', '2020-08-08 15:32:36', NULL);
INSERT INTO `uc_user` VALUES (139, '江城_圻', '男', NULL, NULL, NULL, '江城_圻', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/U9gaVhJz3VHfkRCjoGzfrkFCQeawWGGduDfiaWR9qIe1FJJNPrHULZHibJjRVHZRVzyH95ZWQhM5UPUwxvKQ2eGUXpuSMHS9Bd/132', 'oRlwVxKV6N0VXIfcj4zHcEhWaJQY', NULL, NULL, NULL, NULL, '2020-08-18 08:52:05', '2020-08-21 13:22:36', NULL);
INSERT INTO `uc_user` VALUES (141, 'Z_wy', '', NULL, NULL, NULL, 'Z_wy', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z2oHMlZD459lfjWicFESiaFiaJDmGgMicavicCROHegk06HUr8ibHDPLOWkNUsJEHjKBicpXeB5cOO6plicXw/132', 'oRlwVxKr8WsprVZDsatg5wyjZAtg', NULL, NULL, NULL, NULL, '2020-08-25 14:05:54', '2020-08-25 14:05:54', NULL);
INSERT INTO `uc_user` VALUES (142, '雨宙', '男', NULL, '13053100002', NULL, '雨宙', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/Q3auHgzwzM5Gdt0Zibic2ysSQT9o01EEWZqOorpXG6BO3OSPwbcyeJM2Dwuq6oz0VibrevZCN4KDUmmTlwxOeIyog/132', 'oRlwVxO7NfngF1nzCEUJcm2qtqZc', NULL, NULL, NULL, NULL, '2020-09-02 16:37:24', '2020-09-02 16:37:24', '');
INSERT INTO `uc_user` VALUES (143, '我站', '男', NULL, NULL, NULL, '我站', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/ajNVdqHZLLAROnu5ibhvGqKOwlv5RkHiaSnqAWU9Sg9HmdcSENm26bibicyFhVbMOPZTicoicCX5Q0naRglwLKqcRSOg/132', 'oRlwVxFL1VoaNEmKUCXW8uW6sZw0', NULL, NULL, NULL, NULL, '2020-09-02 17:06:28', '2020-09-02 17:06:28', NULL);
INSERT INTO `uc_user` VALUES (152, '浅色月光', '', NULL, NULL, NULL, '浅色月光', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/eytJa9K5jkrghibkzmXrXQ3nI6iaxOgdmlNvvKyLMrsnUL6q3F11cZpJTriaREMGDDuogEFGeVkKlsp9zvebn1u1j7fEgliaT3FC/132', 'oRlwVxHj84JzpqoH2DyXnQSaEeZc', NULL, NULL, NULL, NULL, '2020-09-03 17:12:53', '2020-09-03 17:12:53', NULL);
INSERT INTO `uc_user` VALUES (153, 'Ali崔', '男', NULL, '15810790310', NULL, 'Ali崔', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/mYib6wZlr5DGSxrAJDIziaN8PjBJOCH5JAWoicfxrC5ZLBjhTfibqXMiaatxic1QJ2ttJgUiaQ3vkee7s3EOFKkUhD2PD4G7Qt37u7c/132', 'oRlwVxBVL6znjKhqG3s8kbcJ2mxs', NULL, NULL, NULL, NULL, '2020-09-04 09:55:35', '2020-09-04 09:55:35', '');
INSERT INTO `uc_user` VALUES (154, 'wcy', '男', NULL, '13955081885', NULL, 'wcy', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/KmlQcCu68Z0oS1kgib7xm7KibiaWuDDGZwHH4hdqaJt8N6KF8TBBcAVTgA6fI990IUbXNUx2fEVHb3dfCEG3GibDwpic82Rc4hnTR/132', 'oRlwVxMoheTUGgZgIFZ66UmFEruc', NULL, NULL, NULL, NULL, '2020-09-04 11:42:04', '2020-09-04 11:42:04', '');
INSERT INTO `uc_user` VALUES (155, '', '', NULL, NULL, NULL, '', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/eytJa9K5jkqwz5d2g6UkgCJfxBffW86icusic5Z8hQqw95vLF1Giap6zzr9fdAM5fuEoAD4IE09NNJonKOianOgavr2AXmOLd83m/132', 'oRlwVxG-_LkAdtQ46LGW9Sj7csIc', NULL, NULL, NULL, NULL, '2020-09-07 23:19:07', '2020-09-07 23:19:07', NULL);
INSERT INTO `uc_user` VALUES (156, '梦宝', '', NULL, '18055303365', NULL, '梦宝', NULL, NULL, NULL, 'normal', 'http://thirdwx.qlogo.cn/mmopen/wx4icZOCLPSicicW69xxia7GBFW8sP7NupNGzFR2IEZlY4n3SWvFWApkDS36IUibgSHbMzwj1z1se25hXXr4bN890iauicnVCyBdnp4/132', 'oRlwVxKKe15sWSgRqCCNCoI2H9tM', NULL, NULL, NULL, NULL, '2020-09-08 15:10:59', '2020-09-08 15:10:59', '340203');
COMMIT;

-- ----------------------------
-- View structure for view_role_id_url
-- ----------------------------
DROP VIEW IF EXISTS `view_role_id_url`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_role_id_url` AS select `role`.`id` AS `id`,`role`.`title` AS `title`,`role`.`role_name` AS `role_name`,`role`.`status` AS `status`,`role`.`role` AS `role`,`role_res`.`id` AS `resId`,`role_res`.`r_id` AS `r_id`,`role_res`.`icon` AS `icon`,`role_res`.`url` AS `url`,`role_res`.`url_name` AS `res_name`,`role_res`.`type` AS `type`,`role_res`.`status` AS `res_status`,`role_res`.`permission` AS `permission` from ((`role` join `role_admin_res` on((`role`.`id` = `role_admin_res`.`role_id`))) join `role_res` on((`role_admin_res`.`role_res_id` = `role_res`.`id`)));

SET FOREIGN_KEY_CHECKS = 1;
